<?php include("include/textcenter.php"); ?>
<?php include("include/db.php"); ?>

<html>
<head>
<meta name="description" content="Admin<?php echo $tagdescription?>">
<meta name="keywords" content="<?php echo $tagkeywords?> Main">
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title><?php echo $tagtitle?></title>

<script type="text/javascript" src="simpletreemenu.js">
/***********************************************
* Simple Tree Menu- © Dynamic Drive DHTML code library (www.dynamicdrive.com)
* This notice MUST stay intact for legal use
* Visit Dynamic Drive at http://www.dynamicdrive.com/ for full source code
***********************************************/
</script>
<link rel="stylesheet" type="text/css" href="simpletree.css" />
<link rel="StyleSheet" href="include/css_classes.css" type="text/css">

<!-- Java script function below -->

Read more: How to Set the Textbox Width in JavaScript | eHow.com http://www.ehow.com/how_8496486_set-textbox-width-javascript.html#ixzz1QeX0UpIS
</head>
<body topmargin="0" leftmargin="0" marginwidth="0" marginheight="0" link="#0000FF" vlink="#800080" alink="#FF0000" bgcolor="#FFFFFF">
<!-- -------------------Header---------------------------- -->
<?php include("include/header.php"); ?>
<!-- -------------------End Header---------------------------- -->
<div align="center">

<table border="0" cellspacing="0" cellpadding="0">
	<tr>
		<td width="12%" valign="top">
		<img border="0" src="public/images/homepage/spider16.gif" width="200" height="1"></td>
		<td width="1%" valign="top">
		<img border="0" src="public/images/homepage/spider16.gif" width="16" height="1"></td>
		<td width="86%" valign="top">
		<img border="0" src="public/images/homepage/spider16.gif" width="16" height="1"></td>
	</tr>	
	<tr>
		<!-- ///////////////////Begin Leftmenu/////////////////// -->
		<td width="12%" valign="top" bgcolor="#FFFFFF">
		<?php include("include/leftmenu.php"); ?>
		</td>
		<!-- ///////////////////End Leftmenu/////////////////// -->
		
		<td width="1%" valign="top" background="public/images/homepage/16.gif">&nbsp;</td>
		<td width="86%" valign="top">
	<br>
<!-- -------------------Begin Body---------------------------- -->
    <form id="chkForm" name="chkForm" method="post" action="order_print_list.php"> 
   
    <a href="order_reportnotcomplete.php">Report all order not complete</a><br />
    <a href="order_reportcomplete.php">Report all order complete not shipping</a><br />
    <a href="order_reportshipping.php">Report all order shipping</a><br />
    <a href="order_reporttoday.php">Report all order today</a><br />
    <a href="order_reportshippingtoday.php">Report all order shipping today</a><br />
    <a href="order_reportshippingthismonth.php">Report all order shipping by this month</a><br />
    <a href="order_reportbymonth.php">Report all order by this month</a><br />
    <a href="order_report_sellertoday.php">Report all products sold today</a><br />
    <a href="order_report_sellerbymonth.php">Report all products sold by this month</a><br />
    <a href="order_reportbyphone.php">Report order by phone</a><br /><br />
    <div>
    <?php
    $datenow = date('Y-m-d H:i:s', time());
    $lastdate = date('Y-m-d 00:00:00', time());
    $sql = "select count(order_id) as totalrecord, sum(total) as total from vnf_shop_order where order_status = 1";
    $result = mysql_query($sql);
    $sql1 = "select count(order_id) as totalrecord, sum(total) as total from vnf_shop_order where order_status = 2 and (date_created between '$lastdate' and '$datenow') 
    or (date_updated between '$lastdate' and '$datenow')";
    $result1 = mysql_query($sql1);
    $sql2 = "select count(user_id) as customer from vnf_shop_order";
    $result2 = mysql_query($sql2);
    
    $sql3 = "select count(user_id) as customernew from vnf_shop_order where (date_created between '$lastdate' and '$datenow') 
    or (date_updated between '$lastdate' and '$datenow')";
    $result3 = mysql_query($sql3);
        ?>      
                <fieldset style="width: 40%;">
                <legend><b style="color: #F9F; font-size: 15px;">Order information:</b></legend>
                <table>
                <tr>
                <td>
        <?php
           while($row = mysql_fetch_assoc($result))
        {
        ?>
                Orders ready for shipping:
                </td>
                <td>
                    <?php echo  $row['totalrecord']?> &nbsp; &nbsp;<?php echo  "$".$row['total']?>
                </td>
                 </tr>
        <?php
        }
          while ($row1 = mysql_fetch_assoc($result1))
        {
        ?>
                <tr>
                <td>
                <p>Orders shipped today:&nbsp;</p>
                </td>
                <td>
                <?php echo  $row1['totalrecord']?> &nbsp; &nbsp;<?php echo  "$".$row1['total']?>
                </td>
                </tr>
                </table>
                </fieldset><br />
        <?php
        }
         while ($row3 = mysql_fetch_assoc($result3))
                {
        ?>
            <fieldset style="width: 40%;">
                <legend><b style="color: #F9F; font-size: 15px;">Customer information:</b></legend>
                
                <p>New customer orders: &nbsp;<?php echo  $row3['customernew']?></p>
        <?php
            }
        
            while ($row2 = mysql_fetch_assoc($result2))
            {
        ?>
                <p>Total customers:<?php echo  $row2['customer']?></p>
            <?php
                
            }
           
            ?>
         </fieldset>
    </div>
</form>
<br />
<!-- -------------------End Body---------------------------- -->

&nbsp;</td>
	</tr>

</table>

</div>
<!-- ----------------------------------------------- -->
<!-- \\\\\\\\\\\\\\\\\\\\\Begin Footer\\\\\\\\\\\\\\\\\\\\\ -->
<?php include("include/footer.php"); ?>
<!-- \\\\\\\\\\\\\\\\\\\\\End Footer\\\\\\\\\\\\\\\\\\\\\ -->
</body>

</html>

